UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X1xyzNz0ixegGdffQ+PGX1gY4owZmSNYQNSgZVq1Krw='
WHERE
key_id = 'c80c2a39f122dd97ba54df7eb342ea2405d1b635cff92674f510cafbde64188f'
AND (
token = 'X1xyzNz0ixegGdffQ+PGX1gY4owZmSNYQNSgZVq1Krw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)