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