UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w3G9a6PYL8oHYmMweGwzT8nGNTa01NrweFCVd1uArXU='
WHERE
key_id = 'dae6013c350d4d2bc1aae649f372e6c4b2f992238c98dea1710e4774a3b9a3fc'
AND (
token = 'w3G9a6PYL8oHYmMweGwzT8nGNTa01NrweFCVd1uArXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)