UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4V6Q5lPVt0iY809Z/C6oobeQIz8V/RYodF4Qau2YpKk='
WHERE
key_id = '3e8fe52076a28f17aef67ecc806073e29a1a4b2f304bc958bf8cd2166434e471'
AND (
token = '4V6Q5lPVt0iY809Z/C6oobeQIz8V/RYodF4Qau2YpKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)