UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n4QzOtIKUnJNSzIm8GXnkwhFGraJ+H/5pMcwU29GJfc='
WHERE
key_id = 'a3bc9b467a3a75e81aa0a47c9340546c8f68638308e818da38d9a94a7156c3f5'
AND (
token = 'n4QzOtIKUnJNSzIm8GXnkwhFGraJ+H/5pMcwU29GJfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)