UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YjWMViG+tVq4vHhztgzxG47BX03XozwsNW7xCcJQGEw='
WHERE
key_id = '1d146033d16cedd4b91fe2fd36d9272262551b388b48de5cefd9d13ba693fcc1'
AND (
token = 'YjWMViG+tVq4vHhztgzxG47BX03XozwsNW7xCcJQGEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)