UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Plj8C/albNi4MacaA7F6ark1vaq/OflY+/VTf1W/rww='
WHERE
key_id = 'a27fe47e49ddb012c69696e239f2b8320ad7ec6ff241519523e55af9aedb1c66'
AND (
token = 'Plj8C/albNi4MacaA7F6ark1vaq/OflY+/VTf1W/rww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)