UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x+FY813zHJYE7m0HO1uNBtnbNfdrDMt0hnOnvJGP0d8='
WHERE
key_id = 'd3b496c0a14714b9ac7babb9b0057c040a54f38fa5cdf090e98a99921ff03e21'
AND (
token = 'x+FY813zHJYE7m0HO1uNBtnbNfdrDMt0hnOnvJGP0d8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)