UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gnPdElX+k6n3VjA0/3paZ8PSgvChQKMCmh386EaYVhA='
WHERE
key_id = '0f083436c194710a861914a5896c790d1823e6c71167263bf886e77a42570d10'
AND (
token = 'gnPdElX+k6n3VjA0/3paZ8PSgvChQKMCmh386EaYVhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)