UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'obSNZBcuycJBc3fY9HbXmDG8wZobHCslwCtC0ATy1kA='
WHERE
key_id = '91a56c707afd10861528fa237c44246a6fdf932fa3c84dd8d0c4260172be4ded'
AND (
token = 'obSNZBcuycJBc3fY9HbXmDG8wZobHCslwCtC0ATy1kA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)