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