UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R0UdwrAYCCYAVUYmIuppfWAg37NkdHLMoFhQwv4hx4U='
WHERE
key_id = '4296e323680b2c9aa9f32d82a87fa6be1aabca2151cb2dff97365d30f5b6830a'
AND (
token = 'R0UdwrAYCCYAVUYmIuppfWAg37NkdHLMoFhQwv4hx4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)