UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zRu9BV4Lc8NR/O8cQca7ibeCpdloYVaccwCN8FYoLyk='
WHERE
key_id = '4c399e8f60392c68c1e11d4e94079c09efd27757b5ce2c484eb30f21a8528abf'
AND (
token = 'zRu9BV4Lc8NR/O8cQca7ibeCpdloYVaccwCN8FYoLyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)