UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3NcQmQ2Y4tR/9u6OY1wQbRwQWYOzrBPn6vf09O46uM0='
WHERE
key_id = 'a993261557236417e63e32ac3d864d88e53cf67f613bfee583977faac8fee771'
AND (
token = '3NcQmQ2Y4tR/9u6OY1wQbRwQWYOzrBPn6vf09O46uM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)