UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I9a5NZKvmIbSYJDVTpVmvkHYKiVK7usdD0D1x8wr+TA='
WHERE
key_id = 'ec39a0dbc163432a8e9b7128b076d921b0864843e5d8c47f260c5d1e94c20182'
AND (
token = 'I9a5NZKvmIbSYJDVTpVmvkHYKiVK7usdD0D1x8wr+TA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)