UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4fX4JVqQuXylghODMaxGep3jiEXNNzthAHVsLWn2FlE='
WHERE
key_id = 'd1c1b33c47f26579f620988b160ddeb696694cdcedec4e3dc3a55423027a6a6e'
AND (
token = '4fX4JVqQuXylghODMaxGep3jiEXNNzthAHVsLWn2FlE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)