UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1H6SFqA3WNsFs4cOfERphxqJ13lyt5vHiirIDechJ/k='
WHERE
key_id = '4be20246dc0bccd0f9da74bf7e98f00fb6f989d6800ad6d779445b28177fddf3'
AND (
token = '1H6SFqA3WNsFs4cOfERphxqJ13lyt5vHiirIDechJ/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)