UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZjG32Rj/qgztzZrw8w5wn4yTVK9sgTPIvL2l125F/ts='
WHERE
key_id = 'a9055ed871458de763d59d0ddf3788af11a54ffc4309a6eebd96053222d14eea'
AND (
token = 'ZjG32Rj/qgztzZrw8w5wn4yTVK9sgTPIvL2l125F/ts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)