UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GlLIN9yM7BBnL8YijHJVrTri2Atlzn6AW3EUYwqwpWI='
WHERE
key_id = 'ca05f1c2d3a6ea893903a58a407676eb15003b3cbe0a47cbec45aad35aca46f7'
AND (
token = 'GlLIN9yM7BBnL8YijHJVrTri2Atlzn6AW3EUYwqwpWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)