UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4EOTcmVg9QOG+3amzaDGCq4r7zQyOd6HqpBllsC/He4='
WHERE
key_id = 'e0d69aaedae49ad6940a00ef63f87ecaee2606775fe3f2e4bb674348b3dca9d0'
AND (
token = '4EOTcmVg9QOG+3amzaDGCq4r7zQyOd6HqpBllsC/He4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)