UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/ZpwRNCQ+GdZIae2JoLJoGTFgT38RoySIW5Bgd7UWC4='
WHERE
key_id = 'ef1af9ad9bd044def0eedfd8abfabea61fd4fcdb6ed949f4ed9b530861f6b4e2'
AND (
token = '/ZpwRNCQ+GdZIae2JoLJoGTFgT38RoySIW5Bgd7UWC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)