UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uA4CUWl0awa59pF31bfYYdozl0KyFgBuf1tXxjkL2x4='
WHERE
key_id = '26e29b496017d7130b0a5a8352067dd887f171e250d3cb0e5f981c4505aa036e'
AND (
token = 'uA4CUWl0awa59pF31bfYYdozl0KyFgBuf1tXxjkL2x4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)