UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pLLXHAKcMwx4L58PxLFs1iDjOe3mNMWrq/B3mAp/t2M='
WHERE
key_id = '7413da749417e90df0c04291a8ac58ac36f897e241b97437a829ef06eec43016'
AND (
token = 'pLLXHAKcMwx4L58PxLFs1iDjOe3mNMWrq/B3mAp/t2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)