UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jU5LkZO0tAvgZaQaE3f6y3hsFZ0dIc87PeYKC0W9gWo='
WHERE
key_id = '9a499db7d3ff50f443c27442ffd1bf7d831ae1110a68fd8beb869ae7747fe1e7'
AND (
token = 'jU5LkZO0tAvgZaQaE3f6y3hsFZ0dIc87PeYKC0W9gWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)