UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bHZeNwqxFsD6mzXhAHsac3sv6OyqG2nSeXE3GUU8U3c='
WHERE
key_id = '3b40c078b05697267e2599c3d282535a0fa56211d8c8cdd88a6137300bffe1e6'
AND (
token = 'bHZeNwqxFsD6mzXhAHsac3sv6OyqG2nSeXE3GUU8U3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)