UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lw/2nkqSq541+oZ7SeKEBPUb+rQBRP8zE0cX4XKad+k='
WHERE
key_id = '38f6d640d66b688237a01399444697862e31d9fa2b40adbf04e75693ac033c1e'
AND (
token = 'lw/2nkqSq541+oZ7SeKEBPUb+rQBRP8zE0cX4XKad+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)