UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FHmXZ5auwYxZXfbNv9OcaT3IUtf9/J7JfjTlKKH4nKc='
WHERE
key_id = '06f3a4ce1897505cfabf57563d1d61ecb7546b1af5fb22e09867e1fba23a8a1e'
AND (
token = 'FHmXZ5auwYxZXfbNv9OcaT3IUtf9/J7JfjTlKKH4nKc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)