UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QlvJqdhPHhZRxs6lhel4k7a817bj3j04ZmnSYwONeNc='
WHERE
key_id = 'dc8274864d3d7655ef4922ff85bdf79c7a1bb81eb073579eefb7d98184376851'
AND (
token = 'QlvJqdhPHhZRxs6lhel4k7a817bj3j04ZmnSYwONeNc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)