UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yjHOErjkuG3xHJlyu/EllrVOGhxc42rXpZs/iUFyBy4='
WHERE
key_id = 'abdc677d5a2252bfbb5ff4cbecc65f4f5adfba30826f7c40b7befde6b9a3dc23'
AND (
token = 'yjHOErjkuG3xHJlyu/EllrVOGhxc42rXpZs/iUFyBy4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)