UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5CgVWdLb+maztuBm7jMzwmmvtxNmOf7WX/he20/gDLg='
WHERE
key_id = 'd92416f191effe75b82f40114f3d05e0cc36ecaeee7f1c6e7934f752f1866f6f'
AND (
token = '5CgVWdLb+maztuBm7jMzwmmvtxNmOf7WX/he20/gDLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)